<%@ page language="java"%>
<%@ page import="com.database.DataBase" %>

<html>
  <head>
   
    <title>My JSP 'VipCardSub.jsp' starting page</title>
   
  </head>
  
  <body>
   <%
         String VipID=request.getParameter("VipID");
         
         String CardLength=request.getParameter("CardLength");
         String CardVerifyStart=request.getParameter("CardVerifyStart");
         String CardVerifyEnd=request.getParameter("CardVerifyEnd");
         String CardVerifyData=request.getParameter("CardVerifyData");
         
         String branchID="1";//request.getSession().getAttribute("branchNO").toString();
         
         DataBase base=new DataBase();
         String sql="update vipcard set VipID='"+VipID+"',CardLength='"+CardLength+"',CardVerifyStart='"+CardVerifyStart+"',CardVerifyEnd='"+CardVerifyEnd+"',CardVerifyData='"+CardVerifyData+"' where branchID='"+branchID+"'";
         System.out.println(sql);
         base.executeUpdate(sql);
         base.closeStmt();
         base.closeConn();
         response.sendRedirect("VipSetSuccess.jsp?branchID="+branchID+"");
   %>
  </body>
</html>
